TRUNCATE TABLE dbo.[role]
GO

SET IDENTITY_INSERT dbo.[role] ON
GO 
INSERT INTO dbo.[role] (role_id, name, description)

SELECT 1,'Administrator', 'Highest level of user access'
UNION ALL 
SELECT 2,'Finance Manager', 'Runs all reports'
GO

SET IDENTITY_INSERT dbo.[role] OFF
GO


